Interested to Buy Any Domain ? << Click Here >> for more details...
can you please explain me pre session and post session options?
- 3 Answers
- 7406 Views
- BTBP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / amedela chandra sekhar
1)Pre session:session execute data before loading the data into target.
2) post session :session execute data after loading the data into target
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / 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 |
Answer / abhinaw prakash
Pre session and post session.
Example: if we want to use bulk mode loading on index tables
it'll fail.
So its something like we can drop the index in pre session
command and again recreate the indexes once the data has
been loaded in post session.
| Is This Answer Correct ? | 1 Yes | 0 No |
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
what r the transformations that r not involved in mapplet?
what is sql override?what is the use of it?
what are the real time problems generally come up while doing or running mapping or any transformation?
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
What is the use of target designer?
I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
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 .
Teradata 
