Which type or t/s is used to convert rows into column &
column into rows
Answer Posted / murugan
By using normalizer transformation we can use the conditions
only applied for row by columns..
by using the normalizer output we can use the function (first)
and then applied for conditions ..and then output will be
seen in column by rows....
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can there be sub steps of etl steps?
Do we need an etl tool?
how do u implement configuration management in Informatica?
Give the benefits of data integration suite?
What are three tier systems in etl?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Explain do we need an etl tool?
What are your responsibilities as an etl tester?
where is the cache (lookup, index) created and how can you see it.
What is the difference between project backlog and product backlog?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Difference between flat files and relational sources?
how do use session mapping parameters ?(in which transformation)
Explain etl mapping sheets?