Answer / dave

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

Answer / rajesh

while we migrate the code by import and export or by Deployment groups, then we will un-check the option retain persistant values.

Now all the values will be reset as new, like resetting SQgen values, Mapping variables ... etc will goes to initial vaules

How will you update the row without using update statergy?

10 Answers   CTS,

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---

What is the functionality of update strategy?

2 Answers  

---

how to load duplicate row in a target

4 Answers  

---

what is degenerated dimension

6 Answers   Cap Gemini,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

---

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

8 Answers   IBM,

---

What is union transformation?

0 Answers  

---

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

wf dont have integration severances how you can run?

0 Answers   TCS,

---