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
Answers were Sorted based on User's Feedback
Answer / sunil
column in to row can be converted by using Normalizer
transformation
| Is This Answer Correct ? | 16 Yes | 11 No |
Answer / babu
Hi Sunil please give detailed expalnation of the above
logic and dfd(data flow diagram ).
| Is This Answer Correct ? | 5 Yes | 0 No |
what is the necessity to use update strategy?(except for updates)
How to use pmcmd utility command?
why we use materialized view over view?
How many mapplets u have created? and what is the logic used
How to delete first 3 rows & last 3 rows in target table in informatica
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
Is informatica power center designer has 64 bit support?
How can repository reports be accessed without sql or other transformations?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
How to add source flat file header into target file?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
What are multi-group transformations?