how can we convert a column into row in informatica?
Eg: INPUT- a x Output Like: a b c
b y x y z
c z
Answer Posted / lv
src--agg--exp--exp--jnr--tgt
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Suppose we do not group by on any ports of the aggregator what will be the output?
According to his methodology what all you need before you build a datawarehouse
Explain the etl program with few examples.
What is the command used to run a batch?
Explain the different lookup methods used in informatica?
What is the difference between router and filter?
What are the different types of olap? Give an example?
What do think which one is the better joiner or look up?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain the use of aggregator cache file?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
can we override a native sql query within informatica? How do we do it?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Which version configuration tool used in ur project?