following table
source target
name gender name target
a1 male a1 female
a2 female a2 male
i want a1 female update to target how will do?
Answers were Sorted based on User's Feedback
The purpose of ur question is to update male to female and
female to male .......... is it so, then
Source --> SQ --> Expression --> Target
Use an expression transformation and make 1 variable port
in it say gender_check, put the condition in it as
IIF(gender=male,female,male)
make a output port say gender_new and give the value of
gender_check as output.Use gender_new as output to target.
Kindly revert if this worked.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / kasi gaddam
Use an expression transformation and make 1 variable port
in it say gender_check, put the condition in it as
IIF(gender=male,female,male)
Is This Answer Correct ? | 0 Yes | 0 No |
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
wht target override?wht advantages it has compare to target update?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Is it possible to define a single node as a Gateway node as well as worker node?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
On which transformations you created partitions in your project?
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
can we use cartesian join in informatica
Do you have to change the reject file b4 using reject loader utility.
What are session parameters ? How do you set them?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
what is data driven in informatica