HiIam learning informatica 8.1 ( which is what i could get my hands on)..I am connecting to oracle 10g.I created 2 connections to the DB using Connection --> Relational Connection Browser.The Source and Target are the same db in this case, just diff table names. But created 2 separate connections .I 1st created the TUTORIAL_SOURCE and then copied it to TUTORIAL_TARGET and gave it a new name. then...

Gatla Dileep reddy

• Feb 16th, 2015

It is a DB issue, If the Session failed in middle just try to recover the workflow.

Vids

• Aug 13th, 2013

The error seems to be DB error . First of all , check at the database level if the source and the target table are created correctly. Then using INSERT stmt , try to insert a record in Oracle databa...

Answer Question  Select Best Answer

Source
id,name
1,a
2,d
3,c

Target
detail
((1/a)(2/b)(3/c))

Manas

• Feb 4th, 2015

We can use expression transformation here in which we can define variables that store the string in the below mentioned way: var1=var1||(||id||/||name||) output_port=(||var1||) After this w...

XYZ

• Feb 4th, 2015

Using a Union Transformation

Answer Question  Select Best Answer

Anjali

• Feb 1st, 2015

Suppose we have two dim Dim_Location and Dim_Customer then how in fact table we can map values of Loc which are corresponding to a customer , if loc has val 1 for Chennai and 2 for Bangalore then how we can show the corresponding loc values for cust ?

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,usually source records are looked up with the records in the dimension table.DIM tables are called lookup or reference table. all the possible values are stored in DIM table. e.g product, all the e...

Answer Question  Select Best Answer

Can any one please tell me how to explain Manufacturing Domain Informatica project in interview as a ETL Developer and from where to start and end.

pradyumna sahoo

• Jan 28th, 2015

Shortly u describe your projects like project name ,& which domain u work? basically u tell your project architecture and its flow .

vijay

• Nov 27th, 2012

Start your project description, then move on to your role and responsibilities and then about your team and so on...

Answer Question  Select Best Answer

Hi Folks,

I have scenario like, I have ten flat files to be loaded in to target but I need to load file names in to a table in mapping level. I think we can do achieve though TC transformation. Unfortunately I did not get though.. Please advise how to implement the logic. ( I need to capture in mapping level only).

This question has been asked one of the interviews.

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

Hi folks, If all files have structure then we go for Indirect file method.we set this property at session level by selecting the source def. After define of the source def at mapping level just do...

Mayur

• Jun 23rd, 2014

Got to flat file properties and there you will find one icon Add FileName column to this table just click on that option and you can able to add currently processing file. Thank you

Answer Question  Select Best Answer

BRAHMAIAH

 Profile Answers by BRAHMAIAH Questions by BRAHMAIAH

• Dec 30th, 2014

There are 3 ways are available to generate sequence numbers with out using Sequence Generator Transformation, 1) Using Exp Tfn variable concept v_cnt(v)=o_cnt+1 o_cnt(o)=v_cnt 2)using mapping variabl...

Venkateswara Rao Rajanala

• Oct 14th, 2014

You can use output port and say CUME(1).. this will automatically generate the sequence or use Variable port
Var= var+1 and Output port = Var...This will generate the sequence for you

Answer Question  Select Best Answer

Nagas

• Nov 24th, 2014

Use the SQL condition "Between and AND" as a filter condition in the mapping

naveenkumar

• Oct 14th, 2014

Execute the target table for mapping to table

Answer Question  Select Best Answer

Hi All,

I am faced with a scenario wherein while data flow from source to target, a condition would be checked that if the data is present in target then a source column will be updated as U and if the data is not present in target then the source column will be updated as I

Vipin

• Nov 11th, 2014

Lookup the target table based on key and check either record is exist or not. If Lookup returns any record then By using update Strategy update or insert. Note : to update record using Update Strategy you need to apply Primary key at INFA Laval at least otherwise it wont work.

KJ

• Nov 10th, 2014

Its never the source but the target column that gets updated with U or I to identify the updated or newly inserted rows.

Answer Question  Select Best Answer

Import flat file from the source (with nulls) it should display without null values in the target

laxmi

• Nov 10th, 2014

We can use validate record component with is_null() function.

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

After importing the flatfile, after the source qualifier use an expresssion transformation. In expression transformation use the condition IIF(column=NULL,0,Column)

(you can use either 0 or any other value u like..)

Answer Question  Select Best Answer

Kiran Ghatage

• Nov 7th, 2014

You will find following tool from informatica marketplace useful for this requriement. https://community.informatica.com/solutions/xml_reporter_for_informatica

kumar

• Sep 28th, 2006

yes, we can generate reports using Metadata Reporter... It is a web based application used only for creating metadata reports in informatica.Using metadata reporter we can connect to repository and ge...

Answer Question  Select Best Answer

Under what conditions selecting sorted input in aggregator will still not boost session performance ?

Venkateswara Rao

• Oct 14th, 2014

If all the rows belong to the same data group . Then it doesn't improve anything

Knonw

• Sep 16th, 2014

If in session property Incremental agg. is enabled. 2. in case of Nested aggregation 3. if treat row as data driven is selected in session property. In all of above cases aggrigator performance wil not be boosted up though its using sorted i/p.

Answer Question  Select Best Answer

How can I maintain unique surrogate key if 2 separate workflow in different repository run at the same time and insert/update the main table.
Please let me know how can I achieve the above scenario.

Venkateswara Rao

• Oct 14th, 2014

In this scenario the best approach is to define a sequence in Database (ex :oracle ).. Call in informatica when ever you want . even if it is across multiple repositories it will work.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Yes, we can. But we need to export/import the mapplet in different repositories. Working with Mapplets: After you create a mapplet, you can validate or edit the mapplet in the Mapplet Designer. You c...

Answer Question  Select Best Answer

We can validate all mappings in PowerCenter Repository Manager window by each folder.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 18th, 2014

Please use this link:

http://www.bullraider.com/database/informatica/scenario/27-informatica-scenario19

gives step by step appoach

lakshmi

• May 27th, 2012

in repository go to menu tool then queries.query browser dialog box will appear.then click on new button. in query editor,choose folder name and object type after that execute it(by clicking the blue...

Answer Question  Select Best Answer

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot Questions by Mahendra Rajpoot

• Sep 17th, 2014

Staging area may be required if you have any of the following scenarios: Delta Loading: Your data is read incrementally from the source and you need an intermediate storage where incremental set of y...

MAHESH MANAM

• Aug 16th, 2012

It is a automated process of building a data warehouse which involves taking the data from disparate source systems, converting them into a consistent form that can be loaded into the warehouse and pe...

Answer Question  Select Best Answer

Employee name start with A pass to one target,Employee name start with S pass to 2nd target,Employee name start with J pass to 3rd target,other pass to other target.

Sandy

• Aug 31st, 2014

To make current answers generic and mapping applies even if you get more names starting with different characters: Use Sorter, Expression & Transaction control transformations - Using sorter transfor...

amrie

• Jul 30th, 2014

In the expression Create a variable port v_employee= IIF( substr(EMPLOYEENAME,1,1)=A,FLAG1 IIF( SUBSTR(EMPLOYEENAME,1,1)=S,FLAG2, IIF( SUBSTR(EMPLOYEENAME,1,1)=J,FLAG3,FLAG4 ))) create a output po...

Answer Question  Select Best Answer

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

Yes, everything is correct. there is also one other thing, you also have to move parameter files. if you forget your mappings will error out. and also you also need to change the values like dev qat s...

Mushi

• Jun 30th, 2014

First - Take a backup and restore of the repository using the Informatica Repository Manager console. Migration can be done at 3 levels: 1.Repository level , 2.Folder level , 3.Object level Steps fo...

Answer Question  Select Best Answer

Which means the first record should come as last record and last record should come as first record and load into the target file?

sandeepsandeep

 Profile Answers by sandeepsandeep Questions by sandeepsandeep

• Aug 11th, 2014

In the Sequence generator, write the query and then order by DESC. this will do a reverse of all records first will go last and last will go first.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

This is pretty simple.

Use sequence generator to number the records.

Then sort them in descending order using sorter transformation.

Answer Question  Select Best Answer

Lookup Transformations can access data from relational tables that are not sources in mapping. With Lookup transformation, we can accomplish the following tasks:Get a related value-Get the Employee Name from Employee table based on the Employee IDPerform Calculation.Update slowly changing dimension tables - We can use unconnected lookup transformation to determine whether the records already exist...

Read Best Answer

Editorial / Best Answer

Answered by: prodyot Sarkar

• Jul 31st, 2007

---

The following reasons for using lookups.....

1)We use Lookup transformations that query the largest amounts of data to improve overall performance. By doing that we can reduce the number of lookups on the same table.

2)If a mapping contains Lookup transformations, we will enable lookup caching if this option is not enabled .
We will use a persistent cache to improve performance of the lookup whenever possible.
We will explore the possibility of using concurrent caches to improve session performance.
We will use the Lookup SQL Override option to add a WHERE clause to the default SQL statement if it is not defined
We will add ORDER BY clause in lookup SQL statement if there is no order by defined.
We will use SQL override to suppress the default ORDER BY statement and enter an override ORDER BY with fewer columns. Indexing the Lookup Table
We can improve performance for the following types of lookups:
For cached lookups, we will index the lookup table using the columns in the lookup ORDER BY statement.
For Un-cached lookups, we will Index the lookup table using the columns in the lookup where condition.

3)In some cases we use lookup instead of Joiner as lookup is faster than joiner in some cases when lookup contains the master data only.

4)This lookup helps in terms of performance tuning of the mappings also.

Satya

• Aug 9th, 2014

Use lookup transformation in a mapping to
--get related values
--perform complex calculation
--Handle slowly changing dimension.

gazulas

 Profile Answers by gazulas Questions by gazulas

• Apr 22nd, 2009

Thats a good question, suppose say you have 40 transformations in your mapping which invole complex agg, functions,? so in middle of the mapping there is a requirement to get the data from some? x t...

Improve Answer

How to write stored procedure,which take the sequence name as input and dynamically generates a nextval from that sequence

Ashish

• Jul 30th, 2014

"sql Create or Replace Procedure P_Get_Value( seqnm IN Varchar2) Is L_Var Varchar2(100); TYPE cur_typ IS REF CURSOR; c cur_typ; Begin OPEN c FOR SELECT || seqnm || ...

Answer Question  Select Best Answer

Gayathri

• Jul 21st, 2014

Go to Session Properties->Config.Object, Make Stop on Error as 0.
This will not fail the session if there is error in 1 record. This will load all error free records.

Dinesh

• Jul 21st, 2014

If the source is FF, then use skip first 299 rows and then start loading.

If the source is relational then u row number.

Answer Question  Select Best Answer