Interested to Buy Any Domain ? << Click Here >> for more details...
How will you convert rows into columns or columns into rows
- 1 Answers
- 2754 Views
- I also Faced
- E-Mail Answers
Answer / ratna
By using the normalizer transformation we can achieve this.
| Is This Answer Correct ? | 0 Yes | 0 No |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
scenario where i can use only concurrent execution of workflow.
What is incremental aggregation?
what is confirmed fact?
What are the types of caches in lookup?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
What is status code?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Mention a few design and development best practices for informatica?
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
Teradata 
