Interested to Buy Any Domain ? << Click Here >> for more details...
How will you update the first four rows and insert next
four rows in a mapping?
- 5 Answers
- 10883 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / adisekhar
->->UPS->TAR
MAPPING DIAGRAM LIKE SRC->SQL->RTR->
->UPS->TAR
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Where are the source flat files kept before running the session?
How to generate sequence numbers using expression transformation?
Explian the Process of deployment groups in informatica
How do you migrate data from one environment to another?
How do you handle two sessions in Informatica
How many ways are there to create ports?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How many ways a relational source definition can be updated and what are they?
What is target load order?
Is there any way to read the ms excel datas directly into informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
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
