How You Pull the records on daily basis into your ETL Server.
Answers were Sorted based on User's Feedback
Answer / munireddy
uning incremental/delta/cdc..
for this we have so many logics some of them are..
using mapping level variable
using control table and ....
| Is This Answer Correct ? | 2 Yes | 0 No |
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
What are the advantages of using informatica as an etl tool over teradata?
Explain what are the different versions of informatica?
In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?
select count(1) from emp? what is the o/p?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
Can we combine a flatfile and a database table using an UNION transformation?
Diffrence between 7.1,8.1 and 8.6
How to convert flat file into xml file? How to tune joiner?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,