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 12799source 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 6690If a table contains 100 records we have to fetch 50-100 records from source to target?how
CSC,
7 10174i 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 7108I 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 9312hi 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 7979PLS 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 3811Can we update a target table (without primarykey) by using update strategy transformation?
TCS,
4 21905What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
TCS,
2 6382Aggregator 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 4235Post New Informatica Questions
What are the advantages of using informatica as an etl tool over teradata?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is a filter transformation?
Explain incremental aggregation in informatica
Explain the different lookup methods used in informatica?
What is aggregator transformation in informatica?
Which version configuration tool used in ur project?
what is the size of your data warehousing?
What are the components of the workflow manager?
Differentiate between a database and data warehouse?
Mention few power centre client applications with their basic purpose?
Under what condition selecting sorted input in aggregator may fail the session?
Explain the shared cache and re-cache?
What are active and passive transformations?
Explain how to import oracle sequence into informatica?