Hi All,
Any informatica Power center or IICS requirement in ur organization?
If yes ,
Can you please refer me?
IIF(AGE <= 20,'below 20',
IIF(AGE <= 30,'21-30',
IIF(AGE <= 40, '31-40',
IIF(AGE <= 50, '41-50',
IIF(AGE <= 60, '51-60','above 60')))))
For age use decode function
Example
Decode(true, age <20 , 'below 20', age >=20 and age <30, 'age below 30 ')
It is 200% scam don't believe all these kind of calls.
If anybody want to give job means , they won't ask you money.
Try this for phone number: '('SUBSTR(i_PHONE_NO,1,3) ')' SUBSTR(i_PHONE_NO,4,3) '-' || SUBSTR(i_PHONE_NO,7,4)
Читать полностью…I ran 2 days back successfully but when I ran now workflow is successful and data not loaded into STG table
Читать полностью…Hi Can any one help me with this question?
How many tables data has been available as of now for a particular table in snowflake. ( How to check this?)