Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
- 10 Answers
- 19569 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / ch naveen kumar
let the attribute name be abcabc and name be aaa and table
name be 1
insert into 2 abcabc from 1 where count(aaa)<5;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you convert single row from source into three rows into target?
What is a filter transformation?
How can you validate all mappings in the repository simultaneously?
How might you approve all mappings in the archive all the while?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
In warehouses how many schemas are there?
What is the need for an etl tool?
How to convert multiple rows to single row (multiple columns) in informatica
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
COM components can be used in Informatica
Is it possible to define a single node as a Gateway node as well as worker node?
According to his methodology what all you need before you build a datawarehouse
can u give example for factless fact table
