How will you convert rows into columns or columns into rows
Answer / ratna
By using the normalizer transformation we can achieve this.
| Is This Answer Correct ? | 0 Yes | 0 No |
who is the best faculty for informatica in hyderabad ameerpet?
can you use flat file for lookup table?why?
what is the drillup & drill down?and use of the drill up and drill down?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Explain what are the different types of transformation available in informatica.
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
how to delete duplicate records by using filter transfermation?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
What is the difference between informatics 7x and 8x and what is latest version?
Why do you use Mapping Parameter and mapping variable?
what is the difference between stop and abort?