Answer Posted / moorthy g

Through Incremental Loading
(using mapping parameter)
so-sq(use SQL Override)-exp(SetMaxVaribale($$date, tr_date))-tar

Did u used latest transformations of 8.6.0? for what?

1882

---

What are the designer tools for creating transformations?

1118

---

Explain the use of aggregator cache file?

1254

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2120

---

Describe an informatica powercenter?

1127

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1083

---

How do you load first and last records into target table?

1159

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2125

---

What is the need of an ETL tool?

1094

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6490

---

Explain the different lookup methods used in informatica?

1042

---

is it possible to index the data in cache of lkp transformation ?

2029

---

What is data transformation manager process?

1156

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2036

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1953

---