Hello friends if you are looking for Data Mapping Multiple choice question with answers | Data Mapping MCQ with answers | Data Mapping PDF File Download | Data Mapping Objective type questions | Data Mapping Questions with answers then you will get all details here only.
1]WHICHOF THESE STATEMENTS ACCURATELY DESCRIBES THE UNIQUE MATCH JOIN MATCH MODEL IN THE MAP EDITOR?
ANS: LAST MATCH IS CONSIDERED AND PASSED TO THE OUTPUT, SET AS DEFAULT WHEN
CONFIGURING AN EXPLICIT JOIN
2]YOU ARE BUILDING AN EXPRESSION IN MAP EDITOR FOR A COLUMN IN WHICH YOU WANT TO PAD THE ROW1.CUSTOMERID STRING WITH LEADING ZEROS UP TO MAXIMUM LENGTH OF 6 CHARACTERS. WHICH CODE CAN YOU USE TO ACCOMPLISH THIS FOR YOU?
ANS: STRING.FORMAT(“$06d”, row1.CustomerID)
3]YOU HAVE MAP EDITOR OPEN FOR A Tmap OBJECT FOR WHICH YOU ARE MAPPING DATABASES OBJECTS. YOU CLICK THE JOIN MODEL FOR A TABLE JOIN PROPERTY. WHICH OPTIONS APPEAR IN THE OPTIONS DIALOG THAT APPEARS?
ANS: INNER JOIN, LEFT OUTER JOIN
4]YOU ARE BUILDING A FILTER EXPRESSION IN MAP EDITOR FOR A COLUMN IN WHICH YOU WANT TO FILTER THE PRODUCT NAME, PRD.NAME TO EQUAL “TURBO WIDGETS”, AND YOU WANT THE TRANSACTION QUANTITY, TX.QTY TO BE GREATER THAN 100. WHICH CODE CAN YOU USE TO
ACCOMPLISH THIS FOR YOU?
ANS: prd.name.equals (“Turbo Widgets”)&&tx.qty>100
5]WHICH COMMON FTP OPERATIONS ARE SUPPORTED BY TALEND OPEN STUDIO COMPONENTS AVAILABLE IN THE PALETTE?
ANS: FILE EXIST, PUT, DELETE
6]ON THE COMPONENT TAB DISPLAYED FOR THE Tsortrow COMPONENT, WHEN YOU CLICK TO ADD CRITERIA TO THE CRITERIA TABLE, TALEND AUTOMATICALLY POPULATES THE COLUMN VALUES WITH
DEFAULTS. IN THE “SORT NUM OR ALPHA?” COLUMN TALEND HA SCHOOSEN NUM BY DEFAULT FOR
CUSTOMER_ID AS DISPLAYED. WHICH OTHER VALUES ARE AVAILABLE FOR THE “SORT NUM OR ALPHA?” COLUMN WHEN YOU CLICK TO OPEN THE DROPDOWN LIST FOR THAT COLUMN?
ANS: ALPHA, DATE
7]YOU ARE USING A tExtractDelimitedFields COMPONENT TO SPLIT THE ADDRESS2 FIELD IN THE DELIMITED FILE AS DISPLAYED. WHAT MUST YOU SPECIFY THE FIELD SEPARATOR PROPERLY FOR THE tExtractDelimitedFields COMPONENT TO PROPERLY SPLIT THE ADDRESS2 FIELD?
ANS: “,” (A COMMA)
8]WHEN CONFGURING THE PROPERTIES FOR A tReplace COMPONENT, YOU CAN OPTIONALLY CLICK THE ADVANCED MODE CHECKBOX. DOING SO ALLOWS YOU TO SPECIFY WHAT TYPE OF EXPRESSION AS THE PATTERN TO SEARCH FOR?
ANS: REGULAR EXPRESSION
9]WHEN CONFIGURING THE PROPERTIES FOR A tAggregateRow component. YOU ARE GOING TO
GROUP BY THE CUSTOMER_ID FIELD IN ORDER TO AGGREGATE THE SALES ON A CUSTOMER_ID BASIS, SO THAT IN THE RESULTING OUTPUT FILE YOU WILL HAVE ONE ROW FOR EACH CUSTOMER_ID WITH
AGGREGATED SALES FIGURES. WHICH FUNCTION VALUE MUST YOU CHOOSE WHEN CONGIGURING
THE OPERATIONS TABLE FOR THIS tAggregateRow COMPONENT?
ANS: SUM
10]YOU ARE USING tNormalize COMPONENT TO NORMALIZE THE CATEGORY FIELD IN THE DELIMITED FILE AS DISPLAYED. WHAT MUST YOU SPECIFY AS THE ITEM SEPARATOR PROPERTY FOR THE tNormalize COMPONENT TO PROPERLY NORMALIZE THE CATEGORY FIELD?
ANS: “;” (A SEMI- COLON)