While using update strategy in the mapping which gives more
performance, a flat file or Table? Why? What are the
advantages and disadvantages?
- 4 Answers
- 7539 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kish`
hi,
update strategy never use for flatfiles....plz correct me,
if it is wrong
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / krish
flat file
bcz no connections needed no network busy etc;
| Is This Answer Correct ? | 0 Yes | 5 No |
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What is best approach to load 100 different source files (Different structure) to differet target tables ?
Can i create a lookup table without cache.
What are the various types of transformation?
How do you implement scheduling in Informatica?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Scheduling properties,whats the default (sequential)
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
what is surrogate id ?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
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
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Teradata 
