Interested to Buy Any Domain ? << Click Here >> for more details...
If one flat file contains n number of records., we have to
load the records in target from 51 to 100.. how to use
expressions in Informatica..?
- 6 Answers
- 15557 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reena
use sequence generator to get row no. for each record ,then
use filter giving the condition (row no.greater than 50 and
less than 100)
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / chakri
Use count variable
Use Variable port
Expression transformation
(Count>50) and (count<100)
Please let me know any information
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / gurava reddy
Source-SQ-SEQ-FILTER-TARGET
1.Connect the sequence genarater(NEXTVAL) to filter in filter
IIF(NEXTVAL>=50 and NEXTVAL>=100,TRUE, FALSE)
2. Then connect the ports to destination(Target)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / susanta
We can filter the records in UNIX itself, then we can use
that filterd file as a source to the mapping.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sujana
i dont think count works in dis scenario...first answer works
| Is This Answer Correct ? | 1 Yes | 3 No |
Can we create multiple integration service on single repository?
How you prepared reports for OLAP?
Why touse stored procedure in ETL Application?
What do you mean by filter transformation?
What is joiner change?
Where do you create/define mapping parameter and mapping variable?
What are the measure objects?
Explain grouped cross tab?
You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000
How to generate a single mapping for both the historical and incremental load.
in oracle write query yourname+1 from dual
What is repository manager?
Teradata 
