How can you change from reusable session into non-reusable
session.
Answers were Sorted based on User's Feedback
Answer / manasa
You can create a non-reusable transformation/session from a
reusable transformation/session in informatica. Select the
object (transformation/session/task) and drag it to the
workspace and just before leaving into the workspace hold
the ctrl key and then release the object
| Is This Answer Correct ? | 67 Yes | 11 No |
Answer / gajendra nagapurkar
Create a Session in Workflow Designer, then the session is
Non-reusable.
All the sessions you create in Task Developer are Reusable
Sessions.
| Is This Answer Correct ? | 20 Yes | 2 No |
Answer / amedela chandra sekhar
If u devlope the session in work flow manager that is
standlone session.that is not reusable first.we can't
achieve if you create session in work flow.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / koti
by developing the session in work flow manager we can
achieve this...
| Is This Answer Correct ? | 7 Yes | 16 No |
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
how to join the 2 different table with different columns in informatica?
what is scd?
What is limitations of truncate and load option
What is mapplet and a reusable transformation?
what is the diff b/w target load plan and cbl?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
Under what conditions selecting sorted input in aggregator will still not boost session performance?