What is a candidate key?

7 Answers   CTS,

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

What are the different types of Type2 dimension maping?

2 Answers   CTS,

---

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

---

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

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

0 Answers  

---

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,

---

How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---