Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 14470 Views
- CTS, I also Faced
- E-Mail Answers
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 |
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
when will we go for unconnected lookup transformation in Informatica?
Please let me know how to make encryption and decryption with example?
Target is zero file and how can you send the email?
How to recover the standalone session?
What is the difference between a connected look up and unconnected lookup?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
Explain informatica architecture - version 8 / 9
How/where can i install Informatica software with oracle or teradata as database
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
What is the different lookup cache(s)?
What are the performance considerations when working with aggregator transformation?
Teradata 
