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
- 15826 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 |
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
What is joiner cache?
What is a poling?
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
Explain grouped cross tab?
How will the document be delivered to me?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Which kind of index is preferred in DWH?
How to use Normalizer transformation?
How to extract sap data using informatica?
What is a difference between complete, stop and abort?
Teradata 
