Interested to Buy Any Domain ? << Click Here >> for more details...
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
- 0 Answers
- 1111 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Difference between Target-based loading and constraint-based loading?
Explain the different lookup methods used in informatica?
What is update strategy transform?
What are the challenges you have faced in your project?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
Why update strategy and union transformations are active? Explain with examples.
What is sql query override? When did u use sql query override?
How will you update the first four rows and insert next four rows in a mapping?
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.
i have two source data there is no pk,fk how to join the two sources
how the server recognises , if the session fails after loading the 100 records in to the target
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
Teradata 
