Status code provides error handling for the informatica server during the session.The stored procedure issues a status code that notifies whether or not stored procedure completed sucessfully.This value can not seen by the user.It only used by the informatica server to determine whether to continue running the session or stop.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Apr 11th, 2014

Status code is used to determine the status of the execution of the code. i.e. if you used command task, Informatica will post the command to OS and when it is completed the OS will return a status c...

Answer Question  Select Best Answer

venkat

• Apr 11th, 2014

We can not use folloeing transformations in a mapplet. Target: This will change the difference between mapping and mapplet. XML and COBOL sources. Normalizer: Im not sure if we can use it as a trans...

prafulla kumar nayak

• Mar 18th, 2014

Below objects we can use inside maplet

1.Non reusable sequence generator transformation.
2.pre or post stored procedure transformation.
3.Normalized transformation
4.xml source qualifier transformation
5.xml source
6.target

Answer Question  Select Best Answer

Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.

sandeepbabu

• Apr 21st, 2014

Maplet is a resuable object,created with business rule using set of transformations and maplet is created with i/p maplet transformation and o/p tarnsformation. Maplet can be created without i/p maplet transformation.

It can be divided into two type:

1)active maplet
2)Passive maplet

abhishek_upadhyay

 Profile Answers by abhishek_upadhyay Questions by abhishek_upadhyay

• Sep 18th, 2008

Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by?keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer.

Answer Question  Select Best Answer

Sumithav29

 Profile Answers by Sumithav29 Questions by Sumithav29

• Jun 26th, 2014

In the File propertes, we have an option Number of intial rows to skip

Rajesh

• Jan 31st, 2014

From Import Flat File Wizard, Edit the setting - Start Import At Row value as 3, that would skip/remove the first and second record and start importing from the third record.

Answer Question  Select Best Answer

Normalizer Transformation. When U drag the COBOL source in to the mapping Designer workspace,the normalizer transformation automatically appears,creating input and output ports for every column in the source.

Ramesh Reddy

• Jul 7th, 2014

This is a type an active transformation which allows to read the cobal files....
the cobal source definition associated with normalized transformation....
Use Normalizer T/R to perform data pivote.. the data pivote is a process of converting a single input record into Multiple output records.....

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

The Normalizer transformation normalizes records from COBOL and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a ...

Answer Question  Select Best Answer

Hi,I am just wondering if there is a direct way to load Excel file into database using Informatica without having to convert Excel to .CSV or XML format. Because we may have to load data from different Excel worksheets.Thanks in AdvanceSrini

Sreedhar Lokaray

• Jul 11th, 2014

We have a separate client tool in Informatica called B2BDT. Earlier it was called as Complex Data Exchange. This tool is used to read data from different sheets of an xls. Not only xls it can be used to read data from pdf, word docs etc.

Manohara Devara

• Jul 3rd, 2012

Hi
Go to source and create required ports and send to Expression..there we need to converted the delimiter file or Comma separate file by using the ltrime and rtrime values...and send to target ....

Answer Question  Select Best Answer

ash.singh1790

 Profile Answers by ash.singh1790 Questions by ash.singh1790

• Jul 13th, 2014

1. Session Properties
2. Under General Options ---> Check "Enable Test Load" ---> Insert 10 in "Number of rows to test"

Mayur

• Jun 19th, 2014

In Session property we have one option that is Performance data check, if you click that option you it will give transformation wise result.

Answer Question  Select Best Answer

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Jul 14th, 2014

Yes, We can!

Open the folder where the reusable transformation is existing.

Then open mapping designer then drag the reusable transformation to mapping designer area. Now hold the Ctrl key and drop it.

Now you have non reusable version of your reusable transformation.

Thanks

Bibhu

• Jul 4th, 2014

Yes, we can. It can be done in the transformation developer.

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

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

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

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

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

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

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

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

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

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

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

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