Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
Answers were Sorted based on User's Feedback
Answer / anu
take sequence annd router t/r 's
connct nextval port to router
create one group mod(nextval , 2)=0-------target1
default group-----------------------------target2
this is applicable to above six source rows only
this is my second logic
tell me any corrections
Is This Answer Correct ? | 7 Yes | 3 No |
Answer / anu
Select distinct in sorter t/r
then run session twice
but don't enable truncate option in session target properties
I think so
any corrections tell me
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / arjun
hi,
take aggrtr in that take one var , count the var group by i/p these go to one tgt and take another same tgt for that, take aggrtr ports i.e, i/p and var ports to filter in that give cndtion not isnull(var) and take i/p port to secnd tgt.
Is This Answer Correct ? | 0 Yes | 0 No |
how to work with mapplet designer in informatica?
What are the data movement modes in informatcia?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Which transformation should u need while using the cobol sources as source defintions?
What is a look up function? What is default transformation for the look up function?
Hi experts, can anyone tell how much we use plsql in real time
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is surrogate key?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
difference between source based commit? and target based commit? which is better with respect to performance?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??