-
Why use the lookup transformation ?
To perform the following tasks. Get a related value. For example, if your source table includes employee ID, but you want to include the employee name in your target table to make your summary data easier to read. Perform a calculation. Many normalized tables include values used in a calculation, such as gross sales per invoice or sales tax, but not the calculated value (such as net sales). Update...
vivek1708
- May 8th, 2008
Hi The ans to ur question is YesThere are 2 types of lookups: Dynamic and Normal (which you have termed as Static).To configure, just double click on the lookup transformation and go to properties tab...
binoop
- Mar 22nd, 2007
For maintaining the slowly changing diamensions
-
How can you say that union Transormation is Active transformation.
h02kkvel
- May 15th, 2008
Hi all, some people saying that a union T/R eliminates duplicates. but it is woring . As of now it wont eliminate duplicates.The union T/R is active and...
Ravi
- Sep 25th, 2006
Hi, Union also Active tranformation.because it eliminates duplicate rows When you select distinct option in union properties tab.
-
How to reduce load times
Suppose one flat file taking loading time of 3 hrs.How u can reduce that loading time to 1 hr.( No FTP, Not UNIX system to make parallel processing,No splitting file,and all servers and files and targets existing in same system)
rags.sarath
- May 20th, 2008
If ur source is flat file,the pcs reads 1024 bytes perone line.If the line containg the bytes less than this number to improve session performance u can tune the 'Line sequntial buffer lenth" in session properties.
UmaBojja
- Aug 14th, 2007
One?can use Nway partition at the source side.We have to partition the session and give the source file name only for the first partition.Server will automatically takecare.Please check if you have that feature. It?a new feature started from 7.1.2ThanksUma Bojja
-
I have a flat file which i am using as my source , i want to match the records in the flat files with that of my oracle table(using cust_id field). I was advised that i should be using a look up transformation and a filter transformation for this. I am not understanding why i should be using the look up transformation. can anyone please helpThanksNayana
anupama2000
- May 26th, 2008
The purpose of using lookup transformation is to check the existing data in target table with the column cust_id after satsifying the condition the rows obtained are used according to your business logic using filter transformation
SRIRAM N
- May 9th, 2007
You should use joiner, then you can use filter if you want, or you can enter the filter condition in joiner as well.
-
Informatica - connect to the repository server error
I am unable to connect to the repository server in repository administrator console after registering new server
anupama2000
- May 26th, 2008
Hi,SOGOTO SERVICES BYRUN-->TYPE( SERVICES.MSC)START THE INFORMATICA SERVER AND NOW CONNECT IN REPOSITORY SERVER ADMIN CONSOLEOR CHECK THE PAASWORD THAT U HAVE GIVEN FOR REP SERVER
sakthione
- Dec 30th, 2007
Hi friend!Please follow these steps and try to connect the server; My computer properties &nbs...
-
How to enable a already disabled session?
-
How can we capture rapidly changing data?
arunkumarengg
- Nov 23rd, 2007
By using CDC (changing Data capture)
-
How to load the dimension tables from staging areas?
anupama2000
- May 26th, 2008
We need to create them in warehouse designer according to specification and move them to another folder where you can use that as target by generating them in warehouse.
-
What is the need for an ODS(operational data store)
What is the need for an ODS(operational data store) in data warehousing?What are the advantages of using an ODS?
anupama2000
- May 26th, 2008
The need for ODS is to clean the data coming from hetrogenous sources. To maintain data quality for better warehouse which provides good reporting.
pal.amol
- Mar 1st, 2008
The Data cleaning tool name which is been widely used unliked Informatica (ETL tool ) name is FirstLogic.
-
When i try to connect to the repository server i am getting this message can someone help me..Starting Repository [infa_rep](6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit.(6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending.(6016|1292) Informatica Repository Agent starting up.(6016|1292) Security audit trail has been turned off.(6016|1292) infa_rep: Repository runtime manager initialized.(6016|1292) infa_rep: Initialized configuration information.(6016|1292) infa_rep: Initialized request dispatcher.(6016|1292) Database Connection Error : Failed to logon to Database serverORA-12154: TNS:could not resolve service nameDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database using user [] and connection string [].(6016|1292) Service stopped.
anupama2000
- May 26th, 2008
Go to the mapping designer check the source username, after that go to session task double click on it go to mapping tab, check the source connection if the name that is mentioned in this tab is not same as the user name what you have used as source change it to that.
sathishkumar_sundaram
- Nov 7th, 2006
Hi,If you look at the last few lines of the error message,ORA-12154: TNS:could not resolve service nameDatabase driver error...Function Name : ConnectDatabase Error: Failed to connect to database usin...
-
Informatica's connect for SAP R/3
How to connect Informatica's with SAP R/3?
anupama2000
- May 26th, 2008
It is due to wrong server connection, try to assign server correctly because the IP address what you are using may change, so try to resolve IP address in work flow manager -> assign server configuration.
anupama2000
- May 26th, 2008
The Lan connection might have changed or check the net8 configuration setup .
-
What is dimension mapping and what is fact mapping?
anupama2000
- May 26th, 2008
Dimension Mapping: The mapping which uses target as one of the dimension is called dimension mapping, suppose a warehouse has 4dimension tables and 1 fact table that is a star schema of 4 dimensions w...
Raja
- Jun 1st, 2007
Dimension Mapping: In any star schema, we need to load all the Dimension tables first, because they act like reference for Fact,Fact mapping: there is dependency for Fact, which looks up for the Dimen...
-
How to assign session/workflow to a particular SERVER?
How to assign a session/workflow to a particular SERVER? ( I have many servers, I want to assign one workflow to one server)
anupama2000
- May 26th, 2008
Go to assign server in the work flow manager and assign the particular server of your requirements.
-
In case of use of dynamic lookup cache in a lookup transformation, the lookup cache gets updated first and then the target table. What happens if the target table rejects a row after it is updated in the Cache?
ggazulas
- May 27th, 2008
You wont get an error if the row is inserted in dynamic cache and it was rejected in the target table. But remember we are refering to the same table in dynamic chache, so if it is inserted in the cha...
prakash
- Nov 26th, 2007
Data in the target table does syncronize. here you wont get any error but the result will not so accurate. so update it in the trg or you can use update strategy transformation as insert after lookup
-
What is the economic comparision of all the Informatica versions?
ggazulas
- May 27th, 2008
Economic comparision is nothing but the price-tag of informatica available versions.
-
-
Delete Informatica repository
I am using Informatica 7.1.1, How to delete the existing repository, mappings?
hasim_geek
- Jun 6th, 2008
To delete repository- Delete it from Informatica Server Administrative ConsoleTo delete Mapping - Delete it from designer.To delete folder - Delete it from Repository Manager.
-
How to run a workflow without using GUI i.e, Worlflow Manager, Workflow Monitor and pmcmd?
-
How can we calculate the fact table size?
nandu214
- Jun 17th, 2008
Hi we can calculate the size depending upon how much period and how many products for how many customers information u want to store like this we calculate the fact table size.Ex:- if we have 100...
-
How to use incremental loading when you load data from staging?
nandu214
- Jun 17th, 2008
HiFirst u run initial laod with startdate and enddate next take enddate as startdate for incremental loading it wil add the data for previous like this we can do incremental loadingHope this helps
Informatica Interview Questions
Ans