What is mapping debugger?
No Answer is Posted For this Question
Be the First to Post Answer
what are 3 tech challenges/ common issues you face?
What is synonym?
Which are the different editions of informatica powercenter that are available?
How union transformation is active ?
What is a sequence generator transformation?
Which is the t/r that builts only single cache memory?
lookup transformation with screenshots
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
What is source qualifier transformation in informatica?