Interested to Buy Any Domain ? << Click Here >> for more details...
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
- 2 Answers
- 7732 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gm
In This Case We have to do source partion. It means source
may be divided into sevral sources. DBA people will do.
After that create mapping for every source and make it
parralles session. and same target.
================================
Easy To Say: We have to do partion in source.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / vivek
I think before sending
data from the source if we
sort the data by sql
override i.e by adding a
"order by" clause in
default sql querry then
our problem wil be solved.
| Is This Answer Correct ? | 0 Yes | 12 No |
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Useful UNIX commands regular/frequently used
In target table how to display the system time
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the difference between Active and Passive transformation?
What are active and passive transformations?
Examples of Fatal & Non-Fatal error?
How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?
How Union Transformation is an Active Trans?
Teradata 
