Interested to Buy Any Domain ? << Click Here >> for more details...
If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 12198 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / imran
use a Sequence Generator T/R........
GO to SG T/r-->Properties (Set the values as shown below)--->
1) 'Enable' the Cycle Option
2) give 'Start value' as 50
3)End Vale 100
4) Increment BY 1
5) Connect Nextval & Currval o/p ports to Target
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is a shortcut and copy in Informatica and how two are different with each other?
How are the sources and targets definitions imported in informatica designer?
Where do we use mapping variables in informatica?
How to partition the Session?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How big was your fact table
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How do you load alternate records into different tables through mapping flow?
what is the Default Source Option For Update Strategy Transformation?
expain about the tune parameters?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is a rank transform?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
