can we have to do changes in session property when we are dynamically generating target files?

Answers were Sorted based on User's Feedback



can we have to do changes in session property when we are dynamically generating target files?..

Answer / priyank

Use Transaction Control Transformation to generate target
files dynamically. While importing the target file, a button
"F" is present in the last on top right. Clicking that, a
port "FileName" is created of size 255.

Is This Answer Correct ?    4 Yes 0 No

can we have to do changes in session property when we are dynamically generating target files?..

Answer / shalaka

Yes, we have to give Db Connection information in session property

Is This Answer Correct ?    2 Yes 2 No

can we have to do changes in session property when we are dynamically generating target files?..

Answer / dhanasekar

Yes we can make changes in the session property. IT is only flat file names for dynamic file creation and we can create it using TCT and in the session properties we can give the destination folder.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,


What are the uses of a Parameter file?

3 Answers   CSC,


follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

5 Answers   IBM,


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,






How to do unit testing in informatica?

0 Answers  


After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


Differentiate between Load Manager and DTM?

0 Answers  


how to return multiple columes through through un-connect lookup?

1 Answers   DELL,


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,


what is the location of parameter file in informatica?

1 Answers   TCS,


What does command task mean?

0 Answers  


Categories