-
StartTask Command
Hi All,I want to ask about StartTask Command if i have 3 steps in the workflow and i want to ignore the first step and start workflow from step 2,so is the StartTask command will start Step2 then step3 or it is only start the step2
-
Convert Source Column into Target Rows
What transformation do you use to convert source column into target rows? Explain
-
Main data object in between Source and Target
What is the main data object present in between Source and Target.
-
What is meant by source is changing incrementally?
What is meant by source is changing incrementally?Explain with an example?
-
Load the remaining rows
Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?
-
-
convert date format in Informatica
I have a requirement to convert date format.my requirement is as followsi hav date column in my source.my source data in date columnv_date10-11-200619-aug-199925-dec-05null11-5-05like thismy requirement is,it has to send me the output as dd-mon-yyyy like 26-nov-2006.if in v_date column required format is not there it has to convert it the correct format,if the record is in the correct format it has...
-
-
-
-
-
Can we use LEFT OUTER JOIN in SQL query override with SAMPLE key word?
Can we use LEFT OUTER JOIN (ANSI SQL standard) in SQ query override with SAMPLE key word?(help me my dba used same in a mapping which have 5 rel SRCS from a single db and contain expression -- directed to TGT)
-
-
-
-
-
Informatica Workflow Monitor properties
When I use the Informatica Workflow Monitor, I can see the properties by double clicking the running session task. But where is the file about the properties, because I want to read the information of the properties through some other development tools. I checked the log file, the it is not what I want. So anyone can help me to get the contents of the properties? Thank you very much~~
-
-
How to send email from Informatica with Post-session success/failure
Hi All,I need to put the value of a col (request-id) in the text of the body of the post-session success/failure email which I have to send in Informatica. How to achieve this? We cannot, I guess, use a Parameter File for this as it would take the same value every time and put it in the email. I want to use the value of request-id which will be different on each session run and capture that value in...
-
Oracle Sequence Generator and Informatica Sequence Generator
The difference between Oracle Sequence Generator and Informatica Sequence Generator?Which is faster in performance?Which is best to use?