| Other Informatica Interview Questions |
|| Asked @
|Can we schedule a workflow(not a session) to run after
completition of another workflow? Can we make a workflow
depend on completition of another one?
|What is a Shortcut and What is the difference between a
Shortcut and a Reusable Transformation?
|| ||1 |
|How to send duplicates to one target and unique rows to one
target?target is empty
|we have 30 wf with 3 batches means 1batch=10 wf
2 batch=10-20 wf
3batch=20-30wf through unix
First you have to complete batch ofter second batch have to
run how can you do in unix?
i want the target
any body give solution above question?
|my source table having firstname.lastname@example.org and email@example.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica
|my table contain duplicate Records i wanna load uniq records
to my table . i have to pass the uniq records through
filter t/r how?
|can we load the data with out a primary key of a table?
what is target plan?
|How mapping parameter and variable works
|| ||1 |
|My source is like bellow
F.NAME M.NAME L.NAME
A B C
D E F
G H I
and out put should like
S.NO F.NAME M.NAME L.NAME
1 A B C
2 D E F
3 G H I
4 UNNOWN UNNOWN UNNOWN
How can we acheive? please explane me indetail
|What is the exact difference b/w IN and EXIST in Oracle..?
|1)can anyone explain how to use Normalizer transformation
for the following scenario
Source table | Target Table
Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh
Ramesh 68 82 78 | ENG 68 73 81
Himesh 73 87 89 | MAT 82 87 79
Mahesh 81 79 64 | ART 78 89 64
please explain what should be
the normalizer column(s)
The GCID column
2)Also please explain the Ni-or-1 rule.
|For more Informatica Interview Questions Click Here |