i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?
Answer Posted / jacob
take one sequence generator and poppulate the sequence nos
to all rows then give condition as sequence no<=7.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Enlist some properties of sessions.
Explain why we use partitioning the session in informatica?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are the static cache and dynamic cache in informatica?
expain about the tune parameters?
can anyone suggest best free Talend data integration training online
How do you load only null records into target? Explain through mapping flow.
What are the various types of transformation?
What is meant by a domain?
What is blocking transformation?
Does an informatica transformation support only aggregate expressions?
What is incremental aggregation?