Interested to Buy Any Domain ? << Click Here >> for more details...
how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 30211 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ghouse
we can write the shell script for it
head -1
tail -1
we call it either in command task or pre and post session
shell commands in seession
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the different options available for update strategy?
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 is the surrogate key?
Performance tuning in UNIX for informatica mappings?
Explain lookup transformation source types in informatica
What is meant by query override?
What is mapplet in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is the use of code page?
In warehouses how many schemas are there?
Is there any way to read the ms excel datas directly into informatica?
