-
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.
-
How can we capture rapidly changing data?
arunkumarengg
- Nov 23rd, 2007
By using CDC (changing Data capture)
-
How to enable a already disabled session?
-
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...
-
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.
-
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
-
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.
-
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
-
Transfer data from xls and ms-access to oracle
How we can transfer data from ms-excel, ms-access to oracle through informatica ? whether it is possible?
aniban
- May 10th, 2008
Both are very much possiblew/ INFA: Write a mapping with src as Excel (or Access) and tgt as Oracle. Note: if your Informatica server is on UNIX, you need to save the XLS as csv and use that.w/o ...
vivek1708
- May 8th, 2008
Ya this is possible. For higher versions of oracle 10g onwardsthis can be done in 2 ways1) without using informatica --MS excel - This can be directly imported into oracle --MS access - Us...
-
Use VSAM file as Target in Informatica
Is it possible to have VSAM file as target? If yes can you suggest me how this can be done?
aniban
- May 10th, 2008
I believe (although not 100% sure) that this is possible. Several years back in one of the projects we had used a tool called STRIVA which could directly read/write in the form of VSAM files. Lately I...
-
Informatica Dynamic Source and Target
Similar to creating dynamic target can we create dynamic source?
-
Why do we need two connections for source? One is designer and another one is workflow manager? What is difference?
deeptisa
- May 2nd, 2008
The first one will be for the debugger in designer. And the other one is for the session in workflow manager.
-
What is intermediate task in informatica? In what situation this task will be executed?
-
What is meant by source is changing incrementally?
What is meant by source is changing incrementally?Explain with an example?
N SRIRAM K
- Apr 14th, 2008
The data in the source is not STATIC..It may change (the no. of records - addition or subtraction) over the period of time or Session run to session run....ThxSRIRAM N
Vani_AT
- Mar 28th, 2008
I think, source is changing incrementally means new rows are getting inserted into the source. For example, If a source on day1 has 10 records; then on day2, 5 new records got added along with the pre...
-
Can u start a session inside a batch idividually?
We can start our required session only in case of sequential batch.in case of concurrent batch we cant do like this.
Vani_AT
- Apr 1st, 2008
Yes, we can do this in any case. Sequential or concurrent doesn't matter.Ther is no absolute concurrent workflow. Every workflow starts with a "start" task and hence the workflow is a hybrid.
-
What r the session parameters?
Session parameters r like maping parameters,represent values U might want to change between sessions such as database connections or source files. Server manager also allows U to create userdefined session parameters.Following r user defined session parameters. Database connections Source file names: use this parameter when u want to change the name or location of session source file between session...
Vani_AT
- Apr 1st, 2008
A small correction, it starts with single dollar symbol . double dollar symbol is used for mapping parameters.
Vani_AT
- Apr 1st, 2008
In addition to this we provide the lookup file name.The values for these variables are provided in the parameter file and the parameters start with a $$ (double dollar symbol). There is a predefined f...
-
How can u stop a batch?
By using server manager or pmcmd.
VEMBURAJ.P
- May 28th, 2007
By using menu command or pmcmd.
-
Can u start a batches with in a batch?
U can not. If u want to start batch that resides in a batch,create a new independent batch and copy the necessary sessions into the new batch.
-
What r the different options used to configure the sequential batches?
Two options Run the session only if previous session completes sucessfully. Always runs the session.
Vani_AT
- Apr 1st, 2008
I would like to make a small correction for the above answer.Even if a session fails with the above property set,all the following sessions of the workflow still run and succeed depending on the valid...
sn3508
- Aug 24th, 2007
You have to specify those options in the workflow designer. You can double click the pipeline which connects two sessions and there you can define prevtaskstatus=succeeded. Then only the next se...
-
When the informatica server marks that a batch is failed?
If one of session is configured to "run if previous completes" and that previous session fails.
Vani_AT
- Apr 1st, 2008
A batch fails when the sessions in the workflow are checked with the property"Fail if parent fails"and any of the session in the sequential batch fails.
Informatica Interview Questions
Ans