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 15006source 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 8083If a table contains 100 records we have to fetch 50-100 records from source to target?how
CSC,
7 12540i 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 8629I 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 11332hi 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 9104PLS 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 4747Can we update a target table (without primarykey) by using update strategy transformation?
TCS,
4 23669What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
TCS,
2 7449Aggregator 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 4973Post New Informatica Questions
What is decode in static cache?
What is workflow monitor?
What is the use of an aggregator cache file?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
If informatica has its scheduler why using third party scheduler?
What can we do to improve the performance of informatica aggregator transformation?
How many input parameters can exist in an unconnected lookup?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How can informatica be used for an organization?
What is rank index in rank transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the use of code page?
What are the modules in Power Center
What are the differences between joiner transformation and source qualifier transformation?