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 / sunil
column in to row can be converted by using Normalizer
transformation
| Is This Answer Correct ? | 16 Yes | 11 No |
Post New Answer View All Answers
generate date / time dimension in informatica
What are data-driven sessions?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Which transformation should we use to normalise the COBOL and relational sources?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is workflow monitor?
What are the main features of Oracle 8i with context to datawarehouse?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Please let me know how to make encryption and decryption with example?
What is target designer and target load order?
Mention a few design and development best practices for informatica?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is the size of u r source(like file or table)?