Answer Posted / dave

Update the current value in the sequence generator to start
the sequence from the beginning again. And V on reset option
in transformation

What is the need of etl tools?

1120

---

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

2029

---

What are the different lookup cache(s)?

1118

---

What is incremental aggregation?

1083

---

How to extract the informatica rejected data?

1219

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1908

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2271

---

How can we use mapping variables in informatica? Where do we use them?

1200

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5790

---

What is sorter transformation?

1045

---

What are the types of caches in lookup?

1048

---

how many types of dimensions are available in informatica?

1098

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1494

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1039

---

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

2035

---