here file headers are not written in the table how we ca do the file headers

Helpful...

Cutie Pie 🥰🥰🥰

👍

😊

This was well done.

Any idea on how do we get the column names as header in the csv file that is generated?

Nice video

How to get the column names in the CSV file which we have unaloded??

No audio.

NO AUDIO ITS CATSTROPHIQUE :D

Errors in implementation

no audio...

Hi Praveen, is it possible to convert or map a Json file into CSV?? could you please post a video on that???

CDC concept not used here at all.

Is it possible view to table mapping

Great video. Works like a charm. Thanks alot :-)

Hi Praveen, how are you doing? I will like to use this medium to say thank you for the all the great video's that you've been posting on your channel. With that been said, Praveen, I have requirement to dump some data(s) from on-premises to Oracle Object Storage using "ODI 12c." I have tried using ftmcli by first loading into a flat file. Things I have tried 1) Created a mapping from Table to Flat file 2) Ran the mapping using a custom IKM that I got from a friend 3) Was able to load to the flat file but the KM "did not send it to the object storage." So, I was wondering if you have any custom KM that can help me in achieving this task by supplying my cloud authentication parameters. And, I'm using ftmcli latest version 2.4. Thanks, any help will be greatly appreciated.

worth watching it

Hi Praveen, why the file is not created in the location I specified

Hi Thanks for your video. Is it work for only Insert and Update. I have one scenario. I want to delete the data in target if the source data is deleted. Can you provide some insights on this.

Hi Praveen, Thank you for the video. How to load the data with heading(column names) information.

Hi Praveen, I am unable to achieve SCD type2. Every time data is appending to the target table.

Nice video...was very informative...

Hi, Thank you for the video, it was useful to learn the "sqlunload utility". But I have an issue, how to load the data with headers and why is that I am not able to use "IKM SQL to FIle Append" in my mapping. Can you please help me with this. Thank you.

good ..praveen could please upload procedures, packages,load plans,scenarioes, and agents topics videos ...........Thanks praeen

hi, Thank you for such a nice collection, kindly update it time to time. it helps a lot. i have a question regarding CDC, i am following your vedio "ODI 12C Check Knowledge Module Mapping on Constraints and CDC" when i subscribe to sunopsis, the log window contain the following error. 014-11-09 11:53:59.348 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist Failed query text: alter table CDC.J$SRC_DEPT modify ( JRN_SUBSCRIBER VARCHAR2(400 CHAR) ) what is sunopsis and why not the table CDC.J$SRC_DEPT is created? when i start the journal, i receive the following errors 2014-11-09 12:03:38.555 WARNING SQLCommand execution failure: ORA-01430: column being added already exists in table Failed query text: alter table CDC.SNP_SUBSCRIBERS add ( JRN_ROW_COUNT NUMBER(20) null, JRN_DATA_CMD VARCHAR2(2000 CHAR) null, JRN_COUNT_CMD VARCHAR2(2000 CHAR) null ) 2014-11-09 12:03:38.719 WARNING SQLCommand execution failure: ORA-00955: name is already used by an existing object Failed query text: create table CDC.SNP_SUBSCRIBERS ( JRN_TNAME VARCHAR2(61 CHAR) not null, JRN_SUBSCRIBER VARCHAR2(400 CHAR) not null, JRN_REFDATE DATE null, JRN_ROW_COUNT NUMBER(20) null, JRN_DATA_CMD VARCHAR2(2000 CHAR) null, JRN_COUNT_CMD VARCHAR2(2000 CHAR) null, constraint PK_SNP_JRN_SBS primary key (JRN_TNAME, JRN_SUBSCRIBER) ) 2014-11-09 12:03:38.766 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist Failed query text: alter table CDC.J$SRC_DEPT modify ( JRN_SUBSCRIBER VARCHAR2(400 CHAR) ) 2014-11-09 12:06:19.232 NOTIFICATION New data source: [cdc/*******@jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=pdborcl.hct.org)))] 2014-11-09 12:06:34.406 NOTIFICATION New data source: [cdc/*******@jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=pdborcl.hct.org)))] 2014-11-09 12:06:34.462 WARNING SQLCommand execution failure: ORA-01430: column being added already exists in table Failed query text: alter table CDC.SNP_SUBSCRIBERS add ( JRN_ROW_COUNT NUMBER(20) null, JRN_DATA_CMD VARCHAR2(2000 CHAR) null, JRN_COUNT_CMD VARCHAR2(2000 CHAR) null ) 2014-11-09 12:06:34.514 WARNING SQLCommand execution failure: ORA-00955: name is already used by an existing object Failed query text: create table CDC.SNP_SUBSCRIBERS ( JRN_TNAME VARCHAR2(61 CHAR) not null, JRN_SUBSCRIBER VARCHAR2(400 CHAR) not null, JRN_REFDATE DATE null, JRN_ROW_COUNT NUMBER(20) null, JRN_DATA_CMD VARCHAR2(2000 CHAR) null, JRN_COUNT_CMD VARCHAR2(2000 CHAR) null, constraint PK_SNP_JRN_SBS primary key (JRN_TNAME, JRN_SUBSCRIBER) ) 2014-11-09 12:06:34.592 WARNING SQLCommand execution failure: ORA-04080: trigger 'T$SRC_DEPT' does not exist Failed query text: drop trigger CDC.T$SRC_DEPT 2014-11-09 12:06:34.607 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist Failed query text: drop view CDC.JV$SRC_DEPT 2014-11-09 12:06:34.621 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist Failed query text: drop view CDC.JV$DSRC_DEPT 2014-11-09 12:06:34.636 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist Failed query text: drop table CDC.J$SRC_DEPT 2014-11-09 12:06:34.663 WARNING SQLCommand execution failure: ORA-00942: table or view does not exist Failed query text: alter table CDC.J$SRC_DEPT modify ( JRN_SUBSCRIBER VARCHAR2(400 CHAR) ) 2014-11-09 12:06:34.748 WARNING SQLCommand execution failure: ORA-01031: insufficient privileges Failed query text: create or replace view CDC.JV$SRC_DEPT /* This view is created in the work physical schema of the current Data server */ as select decode(TARG.ROWID, null, 'D', 'I') JRN_FLAG, JRN.JRN_SUBSCRIBER JRN_SUBSCRIBER, JRN.JRN_DATE JRN_DATE, JRN.DEPTNO DEPTNO, TARG.DEPT_NAME DEPT_NAME from ( select L.JRN_SUBSCRIBER JRN_SUBSCRIBER, L.DEPTNO DEPTNO, max(L.JRN_DATE) JRN_DATE from CDC.J$SRC_DEPT L where L.JRN_CONSUMED = '1' group by L.JRN_SUBSCRIBER, L.DEPTNO ) JRN, CDC.SRC_DEPT TARG where JRN.DEPTNO = TARG.DEPTNO (+) 2014-11-09 12:06:34.759 WARNING ODI-1134 Agent Internal encountered an error: ODI-1226: Step SRC_DEPT fails after 1 attempt(s). 2014-11-09 12:06:34.763 ERROR ODI-1217 Session SRC_DEPT (61) fails with return code 1031. 2014-11-09 12:06:34.775 ERROR ODI-1134 Agent encountered an error: ODI-1217: Session SRC_DEPT (61) fails with return code 1031. Caused by: ODI-1226: Step SRC_DEPT fails after 1 attempt(s). ---------------------------------------------------------------------------------------------------------------------------- and when i run the jounal, it give the following error ODI-20724: Journalized data not found. Journal data view: CDC.JV$DSRC_DEPT how to fix this issue? Thank you.

Nice Artical