Answer / susanta

Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.

after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.

Hope this will help u

Answer / ks316

Hi all,

I am posting my first post. Excuse me for any
mistakes, In the above answer given i dont think that the
target gets loaded in proper order. According to your
answer all the records gets loaded into all targets.

I think there should be a condition to every group in the
router.


i think the conditio should be like
mod(nextval,3)=0 tgt1
mod(nextval,3)=1 tgt2
mod(nextval,3)=2 tgt3,

pls correct me if i am wrong

Answer / avatar dss42b88

for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure

sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like

start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.

why we use datawarehouse

0 Answers   HCL,

---

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

---

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

---

What is meant by LDAP users?

0 Answers  

---

How to elaborate tracing level?

0 Answers  

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

In target table how to display the system time

1 Answers  

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---