Three date formats are there . How to change these three into
One format without using expression transformation ?
Answer Posted / pradeep
Use SQL Override and apply the TO_DATE function against the
date columns with the appropriate format mask.
Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Explain the etl program with few examples.
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the need of etl tools?
What are the modules in Power Center
What are the measure objects?
On which transformations you created partitions in your project?
What is informatica?
How many ways are there to do 'remove duplicate records in informatica'?
What is decode in informatica?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Enterprise data warehouse your projects phase by phase explain?
What is a joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is source qualifier transformation in informatica?