Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
TCS,
7 10003source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
4 5105If a table contains 100 records we have to fetch 50-100 records from source to target?how
CSC,
7 7799i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
4 5749I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
6 7212hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
2 6801PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
2 2867Can we update a target table (without primarykey) by using update strategy transformation?
TCS,
4 16609What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
TCS,
2 5218Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
TCS,
1 3360Post New Informatica Questions
What is sorter transformation?
How do you load only null records into target? Explain through mapping flow.
Explain in detail about scd type 1 through mapping.
What are the different transaction levels available in transaction control transformation?
How to join three sources using joiner?
According to his methodology what all you need before you build a datawarehouse
What is a surrogate key?
What does update strategy mean, and what are the different option of it?
Is it possible to define a single node as a Gateway node as well as worker node?
what are the deliverables?in your project?
What is informatica etl tool?
How identifying bottlenecks in various components of informatica and resolving them?
What are the tuning techniques you applied during your last project
How can we create index after completion of load process?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?