Interested to Buy Any Domain ? << Click Here >> for more details...
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access)..
(the session should should start from 21 record)
- 0 Answers
- 1630 Views
- Saama Tech, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
Sequence generator, when you move from develoment to production how will you reset
How do you load only null records into target?
Do you find any difficulty while working with flat files as source and target?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Briefly describe lookup transformation?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
how will you remove the duplicate records from flat file without using sorter?
what is mapping performence?
what is session parameters?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
Teradata 
