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
- 15728 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 |
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Clarify the utilization of aggregator cache record?
Differentiate between router and filter transformation?
Write the different tools in the workflow manager?
What if the source is a flat-file?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How do you recover rows from a failed session
How can you differentiate between powercenter and power map?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
What is the difference between warehouse key and surrogate key?
Teradata 
