How to format phone number 9999999999 into (999)999-9999 in informatica

Vids

• Aug 13th, 2013

It can be achieved using the IDQ tool where u can set the standard format . EVen I am not sure how exactly

sreenu

• Dec 4th, 2011

Using the CONCAT (||) operator and SUBSTR function in the expression transformation.

Answer Question  Select Best Answer

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

1. Sort based on ename column.
2. in Exp,
Var_Prev=Var_Curr
Var_curr=ename
Var_Value=IIF(Var_Prev=Var_Curr,Var_Value||,||payments,payments)
Out_Value=Var_Value
3. Aggregator transformation: Pull ename,Out_Value ports from Exp in Step 2.
Group by ename

Hope this helps!!!

abraham deng stephen

• Jul 3rd, 2013

Simple use expression transformation and make all the inputs into the date format given. Add a condition like

Code
 

This is my idea. It helps you hopefully....thx

Answer Question  Select Best Answer

How to delete first 3 rows & last 3 rows in target table in Informatica?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

1. SQ 2. Expression --> Connect the expression with the Sequence Generator 3. Aggregator with one column(key column if any) Out_Count=count(*) Dummy_count=1 3. Expressio...

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Sep 3rd, 2012

Hi,

We can use a sql in the sql override:

select count(1) from
(select * from where rownum

Answer Question  Select Best Answer

In lookup which one is better one connected and unconnected lookup?performance wise i am asking?if i am using five connected lookup in mapping that time what happens?

Ganesh kumar

• Sep 4th, 2013

Yes, I Agree your answer,.....

Baloo_nanduri

 Profile Answers by Baloo_nanduri Questions by Baloo_nanduri

• Jul 25th, 2010

Connected lookup lends best performance and also you can cache or uncache connected look up unconnected look up is used only when you have to use it as a function call both have its own benefits, using 5 connected lookup's is not a big deal until your mapping is tuned well.

Answer Question  Select Best Answer

Venkat

• Sep 10th, 2013

Above answer is not correct.

Correct answer is 150 MB

chandrarekha

• Sep 28th, 2007

10GB

Answer Question  Select Best Answer

Sarita

• Oct 23rd, 2013

The errors faced are:

1)Duplicate data in target tables
2)Performance issues
3)File rejections due to error in header and trailer records
4)Logical errors

Answer Question  Select Best Answer

How do you validate the no of rows received in source with footer(count) and if both count matches then only it should load to target?

vijay

• Jan 6th, 2014

Design a mapping with 2 flow.1 to load the data into target with all necessary columns.2nd target will have only count information and set a target load plan as said above.In the session level. Set th...

saurav

• Apr 4th, 2013

You can utilize the MD5 hash functionality within the mapping

Answer Question  Select Best Answer

Jose

• Jan 27th, 2014

By default the maximum concurrent session is 10 and during installation we are setting the number of concurrent session.

prasadns26

 Profile Answers by prasadns26 Questions by prasadns26

• Jul 18th, 2006

hi,please be more specific on the first half of the question.u set the max no of concurrent sessions in the info server.by default its 10. u can set to any no.

Answer Question  Select Best Answer

If i enable select distince property in sorter transformation, on what basis the sorter tranformation removes the duplicate data

RaghuMVR

• Feb 4th, 2014

It will check all the column values of the records to identify the duplicates.

Karthik

• Jan 13th, 2014

The IS removes duplicates only if it is a row duplicate(entire row should be duplicate)

Answer Question  Select Best Answer

What is the difference between STOP and ABORT options in Workflow Monitor?

Satish

• Mar 4th, 2014

STOP ensures current session activity / threads on Informatica server are complete and ends the workflow.
ABORT kills current session activity / threads on Informatica server irrespective of its state and ends the workflow.

Sudha Rani

• Nov 6th, 2012

If we have to do stop it will stop that step only.again we have to start the workflow then that time it will start which step u have to stop that step only it start run the workflow then abort says we...

Answer Question  Select Best Answer

What is the way to add the total number of records that have been read from SRC in the TGT file as last line? Let me clear you if my TGT is a flat file and want to add total number of records that are written in TGT as a last line with sysdate.

Surbhit

• Apr 1st, 2014

Use an aggregator and do no group by any key

Ankit Kansal

• Feb 15th, 2014

Easy way of achieving the functionality is with Unix commands however if you want to achieve it using Informatica only then Then just before dumping your data to your target use aggregator count() f...

Answer Question  Select Best Answer

During the session ,the informatica server compares an inout row with rows in the datacache.If the input row out-ranks a stored row,the informatica server replaces the stored row with the input row.The informatica server stores group information in an index cache and row data in a data cache.

venkat2ram

 Profile Answers by venkat2ram Questions by venkat2ram

• Apr 11th, 2014

Rank caches are the caches created to calculate the rank while session run for Rank transformation. Index cache and Data cache Index cache stores the values of the key column i.e. rank port here. D...

Answer Question  Select Best Answer

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