what is surrogatekey ? In ur project in which situation u
has used ? explain with example ?
- 6 Answers
- 12253 Views
- I also Faced
- E-Mail Answers
Post New Answer View All Answers
how to load rows into fact table in data warehouse
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.
have u done any performance tuning? how u ll do?
What are some examples of informatica etl programs?
Describe an informatica powercenter?
What is meant by incremental aggregation?
Repository user profiles
Explain the scenario which compels informatica server to reject files?
What do you understand by term role-playing dimension?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How many transformations can be used in mapplets.
permutations of mapplet
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 many numbers of sessions can one group in batches?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
