How mapping parameter and variable works
- 1 Answers
- 3833 Views
- I also Faced
- E-Mail Answers
Answer / abhinaw prakash
In Mapping parameter the value once defined does'nt change
during the session.Once the session completes successfully
the server again reads the data from the beginning.
In mapping variable the value changes during the session and
after the session completes the integration server reads the
data from the last saved value from the last run.
| Is This Answer Correct ? | 3 Yes | 0 No |
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
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
What does reusable transformation mean?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
Can we write to_date(three arguments) ? Will it work ? Advance thanks
wht is full process of Information source to target just like stg to productuon and development
how we can do session partition in informatica any one explain me clearly? thanks advance.
tell me the rules and responsblites in our project(my project is development)
What happens when a session fails and you click on recover?
How to create Target definition for flat files?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Teradata 
