Interested to Buy Any Domain ? << Click Here >> for more details...
I Have 100 Records in a relational tble and i want to load
the record in 3 targets , first records goes to target 1
and second to target 2 and third to target 3 and so
on ,what are the tx used in this and what are the
logics ,can any one help me ?? Thanks in Advance
- 6 Answers
- 15584 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / manu
Hi Srinivas,
Even I gave the same solution. Can you please check.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What the difference is between a database, a data warehouse and a data mart?
What is mapplet in informatica?
What is the Rank index port in Rank transformation?
What are the types of data warehouses?
Can we change Dynamic to Static or Persistent cache? If so what happens?
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
What are the differences between source qualifier and joiner transformation?
Define Pmrep command?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is a dimensional model?
How might you approve all mappings in the archive all the while?
What is an expression transformation?
how to load rows into fact table in data warehouse
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
whats the logic to load the lower level of granularity of data to fact table.
