How You Pull the records on daily basis into your ETL Server.

Answers were Sorted based on User's Feedback



How You Pull the records on daily basis into your ETL Server...

Answer / bharu_295

using incremental loading

Is This Answer Correct ?    4 Yes 0 No

How You Pull the records on daily basis into your ETL Server...

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

Post New Answer

More Informatica Interview Questions

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  


what is target update override and when we use it?

2 Answers   TCS,


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.

1 Answers  






When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  


hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,


if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,


Categories