there is a product table
prodid prodname price
100 cinthol 10
101 hamam 10
102 neem 20
103 cake 30
in the above table the price of some products are
duplicated and some product prices are distinct we want to
push the duplicated prices to one target and non-duplicated
prices to other target without using expression and
sequence generator transformation
Answer Posted / honey
Help me out generating count in informatica.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are factless facts? And in which scenario will you use such kinds of fact tables.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Which development components of informatica have the highest usage?
How to use pmcmd utility command?
Informatica settings are available in which file?
Explain the tuning lookup transformation - informatica
Explain how many types of dimensions are available in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is a sequence generator transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Define enterprise data warehousing?
Write the unconnected lookup syntax and how to return more than one column.
What are the new features of informatica 9.x developer?
What are the issues you have faced in your project? How did you overcome those issues?
How can we remove the duplicates from flat file source?