Interested to Buy Any Domain ? << Click Here >> for more details...
how to identify new and old values in source qualifier or
any other transformations using informatica
- 2 Answers
- 6063 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjay
By using the scd2..we can keep the track of the old and new
records.
There are 3 ways:
1.Version Num
2.Date
3.Flag
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How might you approve all mappings in the archive all the while?
How do you set a varible in incremental aggregation
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Whats there in global repository
What is the difference between stop and abort in informatica
scenario where i can use only concurrent execution of workflow.
What is joiner change?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a router transformation?
Explain the scenario which compels informatica server to reject files?
How to call shell scripts from informatica?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What does refresh system mean, and what are its distinctive choice?
What is union transformation?
