Interested to Buy Any Domain ? << Click Here >> for more details...
If we are using an aggregator but forget to mention the group by port .what will be the output??
11 33731I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
4 10592If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
9 15605Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
5 11726Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
1 6835I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
3 8000HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
TCS,
3 10355Post New Informatica Questions
Explain about cumulative Sum or moving sum?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Why filter transformation is an active one?
Differentiate between a repository server and a powerhouse?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is enterprise data warehousing?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What happens when a session fails and you click on recover?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is a shortcut and copy in Informatica and how two are different with each other?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are ETL Tools?
