Answer / mike

1)Yes..you can use a lookup transformation on flatfiles.

2)I think we can use most of the transformations on
flatfiles.
But we can not apply slowly changing dimensions on flat
files.

correct me if i was wrong

Answer / rajan raorane

No we can apply slowly changin dimensions on flat files
as they are basically used to mantian history

frequently used is SDC2 (Verison/flag/Date)

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

---

what is filelist concept in informatica

4 Answers  

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

---

What is source qualifier transformation in informatica?

0 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---