Informatica Interview Question | iLink Digital | Wipro | Fragma Data| PWC

1. How can you generate seq number without using seq generator?
ID, name, dept
123, Raghu, IT
145, raju, Sales

Target
S.no,ID, name, dept

2. Three source files (FF) having same structure and need to load into single table without using union transformation.

3. Direct and in direct load?

M1: Direct Load

s(FF) --- T(Table)
s(Table) --- T(FF)

M2: In-Direct Method

FF's Table
s1 T1
s2
s3
s4
.
.
.s10

Path:

Please subscribe to my channel and let me know if you have any questions.

Please reach out to me for Informatica Training for Beginners or experienced or who are looking to jump into IT Sector.

What's app/ping me: 6360407797

Thanks,
Adike's Info Tech