Informatica DataQuality Interview Questions
- What are the most used transformations in IDQ?
- What is address doctor?
- Can we export an object from IDQ to Powercenter tool. if yes then how ?
- What is a reference table?
- In IDQ, is possible to create user defined reference tables? In what circumstances can they be required?
- What is a parser transformation?
- What is the functionality of labler transformation?
- How to export all object profile at once ?
- Does IDQ have a emailing system like PowerCenter ?
- How can we publish IDQ SSR results on the Intranet/Web ?
- What type of IDQ plans can be exported as mapplets to Powercenter?
- How to add in one time many physical data object
- Is there a way we can parameterize Notifications Receipients list in Exception task inside a Human Task?
- Can we use Oracle tables as reference tables in IDQ?
- What is address doctor?
- How to check in Informatica Data Quality which fields in range are unique
- What is the algorithm of tools such as DataFlux or Informatica to remove duplicates?
- How do you include you mapping output variables in the workflow without having to use a human task?
Well defined thanks for sharing
ReplyDeleteVisit - www.tekclasses.in
nice questions thank you for sharing. Know more about Informatica IDQ Online Training Course
ReplyDelete1. Most used Transforation : Parser
ReplyDelete2 & 15. Address Doctor - The Address Validator transformation compares input address data with address reference data to determine the accuracy of input addresses and fix errors in those addresses. The transformation can create columns with new address data, corrected address data, and status information for each address.
Ex: Passing the postal code & retrieve all fields available.
3. Yes, we can export an object from IDQ to Powercenter tool.
> Connect to Repositary Service
> Locate your Project Folder in Developer tool
> Expand Mapping tab
> Choose your mapping(Needs to be exported)
> Expand Informatica Folder
> Click Object Export File
> Locate under your project folder select the Mapping/mapplets
> Click Browse and select the Location where you want to export it
4. Referance Tavles - Referance table are use as a guide to compare data from input or can aslo be used as a look up
5. Yes, user defined referance table can be created. IDQ enables users to maintain reference tables where they can define a set of allowed values. For example, a list of country/state codes can be maintained in reference table. When a column is profiled against reference table, it shows the number & detail of addresses that don’t match the country/state codes. Reference tables can be easily created from the list of unique values of column profiles and edit the table to add or remove values from it.
6. It is one of most important transformation used in IDQ. Parsing is the core function of any data quality tool and IDQ provides rich parsing functionality to handle complex patterns.
Parser transformation can be created in two mode
Token Parsing Mode
Pattern Based Parsing
9.Does IDQ have a emailing system like PowerCenter - It has a Email Validation system.
Mailbox - Sub-domain - Domain
A email is declared valid when it all the 3 components are present appropriately.
10. Publishing SSR on Web / New - Thru HTML file
11. Exporting plans - Well you can import you IDQ plan in your mapping by the Data Quality Transformation (DQ). This transformation is available only in 8x versions. first u need to save your IDQ plan as a xml in your machine, and then you need to call this plan in your mapping by creating a new DQ transformation and then your all logic is available in the mapping. One thing about this transformation is when ever you do some change in the plan you need to refresh the DQ transformation. Hope this will answer your question. We have done the same things in our data cleansing projects.
16. How to check in Informatica Data Quality which fields in range are unique - Using Matching Transformation
Field Matching: Use to find similar or duplicate records
Identity Matching: Compares two or more values from a record and calculates the similarity between them
Ohayo,
ReplyDeleteAmaze! I have been looking bing for hours because of this and i also in the end think it is in this article! Maybe I recommend you something helps me all the time?
If that was not the problem, then there are two things which you could try first.
The simplest remedy is (if it works) to repeat that step (setting up the domain database and start the Informatica domain).
If that doesn't work, uninstall the software, reboot the server, and re-install. There is no guarantee that it will work, but in some cases this did help.
I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.
Many Thanks,
kevin
Hola,
ReplyDeleteAmaze! I have been looking bing for hours because of this and i also in the end think it is in this article! Maybe I recommend you something helps me all the time?
And the main mapping you define a mapping variable $$Expr_Var (Make sure you select IS_EXPR_VAR is true. Use the parameter file in the session and use the above variable in the calculation..so it will treat as a expression rather than mere string value.
Hope it should work.
Very useful post !everyone should learn and use it during their learning path.
Thanks and Regards
Howdy Mate,
ReplyDeleteMuchas Gracias Mi Amigo! You make learning so effortless. Anyone can follow you and I would not mind following you to the moon coz I know you are like my north star.
This error is simply because domain database schema is full of old metadata. Until you delete old metadata, you can't create the new domain in it.
For infasetup delete domain or define domain command, refer command reference guide or you can go to any powercenter client >> help >> content >> command reference >> infasetup for full details on how to run the commands.
Awesome! Thanks for putting this all in one place. Very useful!
Kind Regards,
Irene Hynes
Hello There,
ReplyDeleteAmaze! I have been looking bing for hours because of this and i also in the end think it is in this article! Maybe I recommend you something helps me all the time?
An easy way to leverage the $ variables in ICS is if Power Center is being used in conjunction with ICS. This solution will be more directed at Power Center developers and not the "citizen integrator".
1. Go to Power Center designer and create a mapplet.
2. The mapplet will have a single dummy input value.
3. Add a transformation expression to the mapplet and create outputs for any of the build in Power Center variables.
4. The outputs of this mapplet are the built in variables you would like to leverage.
5. Export the mapplet.
6. Import mapplet into ICS.
7. Prior to pushing data into a Target add an expression with all the values being mapped to the target, add the output from the mapplet that you want to useInformatica IDQ training USA, in this case a $PMWorflowRunId which could map to a target table that requires the use of a batch id.
But nice Article Mate! Great Information! Keep up the good work!
Thanks,
Preethi.
Hello Chandni,
ReplyDeleteNice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long.
I started using Informatica Data quality training blog for my training practice.
Is there any other study content beyond the information provided by the courses?
I""""m about to schedule my exam (section 4 in the CDI certification), but wanted to ensure (or find out) if the exam will cover more then what is in the course content.
But nice Article Mate! Great Information! Keep up the good work!
Many Thanks,
Morgan
Howdy Mate,
ReplyDeleteGreat info! I recently came across your blog and have been reading along.
I thought I would leave my first comment. I don’t know what to say except that I have
You should never try to install more than one version of Informatica software on one single Windows machine. That's a really bad idea, the danger is extremely high that you mess up the machine and Informatica IDQ training USA
its configuration. I assumed that you had installed on a "fresh" Windows machine.
Never, never, NEVER install several Informatica versions on the same Windows machine. Never ever.
Super likes !!! for this amazing post. I thinks everyone should bookmark this.
Kind Regards,
Nice post,and good information Thanks for sharing further check it once at Informatica Online Training
ReplyDeleteSAP BW on Hana online training
ReplyDeletesap sd online training
osb online training
oracle scm online training
app v online training
windows admin online training
Mmorpg oyunlar
ReplyDeleteinstagram takipçi satın al
tiktok jeton hilesi
tiktok jeton hilesi
saç ekim antalya
referans kimliği nedir
instagram takipçi satın al
metin2 pvp serverlar
instagram takipçi satın al
Smm Panel
ReplyDeletesmm panel
iş ilanları
instagram takipçi satın al
hirdavatciburada.com
Https://www.beyazesyateknikservisi.com.tr/
SERVİS
tiktok jeton hile