can every transfomation reusable?how?
Answers were Sorted based on User's Feedback
Answer / vijay
except source qualifier tranformation,all transformations
supports reusable property.reusable transformation
developed in two ways.
1.in mapping which transformation do you want to re
use,select the tranformation and double click on it,there
you got option like make it as reusable transformation
option.there you need to check the option for converting
non reusable to reuasble transformation.but except for
source qualifier trans.
2.by using transformation developer
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / usha
every transfomation reusable is reusable except source
qualifier tranformation..
if we create transformation in transformation developer its
reuasable
| Is This Answer Correct ? | 2 Yes | 0 No |
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
How can we integrate different flat file data in a single mapping and with in a single execution
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
What are mapplets?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
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?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?