can you please explain me pre session and post session options?
Answer Posted / gm
Pre_Session and Post_Session are availble in
Source_Qualifier and Target.
In SQ:
Pre_Session:(Pre_SQL)
Something we can do before reading data form Source
Ex: delete some temp files
Pre_Session:(Post_SQL)
Something we can do after reading data form Source
Ex: clean the data according to business requirement.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different options available for update strategy?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Target increases every day even though no new record was inserted
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are junk dimensions?
Explain what are the different types of transformation available in informatica.
Mention few power centre client applications with their basic purpose?
What is primary and backup node?
Reusable transformation and shortcut differences
How to use procedural logic inside infromatica?
How can we use batches?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
update strategy transformation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What are mapplets?